<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

return new class extends Migration
{
    /**
     * Run the migrations.
     */
    public function up(): void
    {
        Schema::create('fake_assistants', function (Blueprint $table) {
            $table->id();
            $table->timestamps();
            $table->softDeletes();
            $table->string('avatar');
            $table->string('name');
            $table->string('hour_price');
            $table->unsignedBigInteger('fake_assistant_type_id');
            $table->text('pictures');
            //可空字段
            $table->string('real_name')->nullable();
            $table->dateTime('birthday')->nullable();
            $table->string('age')->nullable();
            $table->string('phone')->nullable();
            //性格
            $table->string('character')->nullable();
            //星座
            $table->string('constellation')->nullable();
            //住址
            $table->string('address')->nullable();
            //兴趣
            $table->string('interest')->nullable();
            //嗜好
            $table->string('hobby')->nullable();
            //人际关系
            $table->string('relationship')->nullable();
            //身高
            $table->string('height')->nullable();
            //体重
            $table->string('weight')->nullable();
            //胸围
            $table->string('bust')->nullable();
            //腰围
            $table->string('waist')->nullable();
            //臀围
            $table->string('hip')->nullable();
            //皮肤管理
            $table->string('skin')->nullable();
            //沟通能力
            $table->string('communication')->nullable();
            //情绪稳定值
            $table->string('emotion')->nullable();
            //恋爱状况
            $table->string('love')->nullable();
            //家庭状况
            $table->string('family')->nullable();
            //职业
            $table->string('job')->nullable();
            //收入
            $table->string('income')->nullable();
            //例假时间
            $table->string('menstruation')->nullable();
            //身体状态
            $table->string('body')->nullable();
            //工作经历
            $table->string('experience')->nullable();
        });
    }

    /**
     * Reverse the migrations.
     */
    public function down(): void
    {
        Schema::dropIfExists('fake_assistants');
    }
};
